module.exports = {
  up: function(migration, DataTypes, done) {
    // add altering commands here, calling 'done' when finished

    migration.createTable('confirmations',
      {
        id       : {type : DataTypes.INTEGER, primaryKey:true, autoIncrement:true},
        email    : DataTypes.STRING,
        tokenID  : DataTypes.TEXT,
        dateAdded: DataTypes.DATE,
        createdAt: { type: DataTypes.DATE    },
        updatedAt: { type: DataTypes.DATE    }
      },
      {
        engine: 'InnoDB' // default: 'InnoDB'
      }
    );

    done()
  },
  down: function(migration, DataTypes, done) {
    // add reverting commands here, calling 'done' when finished
    migration.dropTable('confirmations');
    done()
  }
}
